Hero image

Captain scarlet's Shop

Average Rating4.04
(based on 68 reviews)

Excel workbooks. and a couple of full lessons

18Uploads

84k+Views

47k+Downloads

Excel workbooks. and a couple of full lessons
Kite Graph for Biotic and Abiotic data
captain scarletcaptain scarlet

Kite Graph for Biotic and Abiotic data

(3)
Plot data onto the spreadsheet and get a kite graph out. If you are looking at environmental factors affecting biotic components of an ecosystem, then this template will plot up to 2 abiotic sets of data over the kite. Thus you can see at a glance if the environmental factors are affecting your biotic species. You may plot any combination, eg, pH and light, or ph and moisture, or temperature and light. there are endless combinations you can look at, whilst comparing to your species research.
Revised Money collection sheet
captain scarletcaptain scarlet

Revised Money collection sheet

(0)
Excel sheet to log all payments for trips out. Easy to use. Please note, some of the sheets are password protected. You do not need the password, it is there to protect the calculations behind the sheet. Up to 190 spaces (pupils) Sheet shows how much paid by each pupil and how much is still outstanding. There is also a sort sheet at the back. Will tell you when the trip has been paid in full. Payment made by pupils an be entered in any order, up to 26 payment increments allowed for.
Kite Diagrams Quadrat sampling  / Graphs template
captain scarletcaptain scarlet

Kite Diagrams Quadrat sampling / Graphs template

(16)
Kite diagram / Graph template This is a very easy to use template, it also contains a couple of easy to follow help pages. It would also be nice if you could comment on the resource. It will only take a couple of seconds, Cheers. Collect data from up to 6 species data types. Enter data, graph plots, Simple. Graphs on 1 sheet for easy comparisons, also 6 large single graphs. See also Kite Graph template, Quadrats, transects sampling + additional plotting of line graph to compare, also available on this TES site, This one plots the kite, as well as being able to plot environmental conditions such as Ph, moisture, light etc. Can be used for both number frequency plots or percentage coverage plots. Version XL5 gives graphs specific for % coverage, whereas the original file had automatic scales. So this would be very good for KS5+ as well as other years. Version SIG has no labels on x axis. REVIEW on this one would be well appreciated.